OperatorHistory

Entity Definition

Logical Name : OperatorHistory
Physical Name : LE_HST_OPR

A collection of monetary and operational totals used to track the activity volume of an operator during a reporting period.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
OperatorID (FK)(PK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
TotalTenderLoanCount The total number of tender loans recorded against the workstation OPERATOR for each REPORTING PERIOD. QU_LON_TND_TOT QuantityTransactionCount decimal(7,0)
GrossPositiveTotalAmount The total monetary amount of positive gross sales recorded by OPERATOR for each REPORTING PERIOD. Positive gross sales exclude returns. CP_SLS_GS_PSTV_TOT Money decimal(16,5)
GrossNegativeTotalAmount The total monetary amount of negative gross sales recorded by OPERATOR for each REPORTING PERIOD. This total only includes returns made to the RETAIL STORE. CP_SLS_GS_NG_TOT Money decimal(16,5)
TotalTransactionCount The total number of transactions recorded by OPERATOR for each REPORTING PERIOD. QU_TRN_TOT QuantityTransactionCount decimal(7,0)
LineItemVoidTotalAmount The total monetary amount of line item voids made by OPERATOR for each REPORTING PERIOD. CP_VD_LN_ITM_TOT Money decimal(16,5)
TotalLineItemVoidCount The total number of line item voids made by OPERATOR for each REPORTING PERIOD. QU_LTM_VD_TOT QuantityTransactionCount decimal(7,0)
PostTransactionVoidTotalAmount The total monetary amount of post transaction voids by OPERATOR for each REPORTING PERIOD. CP_VD_PST_TRN_TOT Money decimal(16,5)
TotalPostTransactionVoidCount The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD. QU_VD_PST_TRN_TOT QuantityTransactionCount decimal(7,0)
TransactionVoidTotalAmount The total number of transaction voids recorded by OPERATOR for each REPORTING PERIOD. MO_VD_TRN_TOT Money decimal(16,5)
TotalTransactionVoidCount The total number of transaction voids recorded by OPERATOR for each REPORTING PERIOD. QU_VD_TRN_TOT QuantityTransactionCount decimal(7,0)
TotalTenderPickupCount The total number of tender pickups recorded against the workstation OPERATOR for each REPORTING PERIOD. QU_PKP_TND_TOT QuantityTransactionCount decimal(7,0)
TenderPickupTotalAmount The total monetary amount of tender pickups by OPERATOR for each REPORTING PERIOD. CP_PKP_TND_TOT Money decimal(16,5)
TenderLoanTotalAmount The total monetary amount of tender loans by OPERATOR for each REPORTING PERIOD. CP_LON_TND_TOT Money decimal(16,5)
ReturnTotalAmount The total monetary amount of returns made by OPERATOR for each REPORTING PERIOD. CP_RTN_TOT Money decimal(16,5)
TotalReturnCount The total number of item returns received by OPERATOR for each REPORTING PERIOD. QU_RTN_TOT QuantityTransactionCount decimal(7,0)
RefundTotalAmount The total monetary amount of refunds made by OPERATOR for each REPORTING PERIOD. CP_RFD_TOT Money decimal(16,5)
TotalRefundCount The total number of item refunds actioned by OPERATOR for each REPORTING PERIOD. QU_RFD_TOT QuantityTransactionCount decimal(7,0)
EmployeeDiscountTotalAmount The total monetary amount of employee discounts actioned by OPERATOR for each REPORTING PERIOD. CP_DS_EM_TOT Money decimal(16,5)
TotalEmployeeDiscountCount The total number of line item employee discounts recorded by OPERATOR for each REPORTING PERIOD. QU_DSC_EM_TOT QuantityTransactionCount decimal(7,0)
MiscellaneousDiscountTotalAmount The total monetary amount of miscellaneous discounts recorded by OPERATOR for each REPORTING PERIOD. CP_DS_MSC_TOT Money decimal(16,5)
TotalMiscellaneousDiscountCount The total number of miscellaneous discounts actioned by OPERATOR for each REPORTING PERIOD. QU_DS_MSC_TOT QuantityTransactionCount decimal(7,0)
StoreCouponTotalAmount The total monetary amount of store coupons accepted by OPERATOR for each REPORTING PERIOD. CP_CPN_STR_TOT Money decimal(16,5)
TotalStoreCouponCount The total number of store coupons accepted by OPERATOR for each REPORTING PERIOD. QU_CPN_STR_TOT QuantityTransactionCount decimal(7,0)
RedeemedContainerDepositTotalAmount The total monetary amount of container deposits redeemed by OPERATOR for each REPORTING PERIOD. CP_DS_RDM_CNR_TOT Money decimal(16,5)
TotalRedeemedContainerDepositCount The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD. QU_DS_RDM_CNR QuantityTransactionCount decimal(7,0)
MarkdownTotalAmount The total monetary amount of price markdowns made by OPERATOR for each REPORTING PERIOD. CP_MRK_TOT Money decimal(16,5)
TotalMarkdownCount The total number of item markdowns actioned by OPERATOR for each REPORTING PERIOD. QU_MKD_TOT QuantityTransactionCount decimal(7,0)
NetSalesTotalAmount The total monetary amount of net sales recorded by OPERATOR for each REPORTING PERIOD. CP_SLS_NT_TOT Money decimal(16,5)
MiscellaneousFeeTotalAmount The total monetary amount of miscellaneous fees recorded by OPERATOR for each REPORTING PERIOD. CP_FE_MSC_TOT Money decimal(16,5)
TotalMiscellaneousFeeCount The total number of miscellaneous fee item sales recorded by OPERATOR for each REPORTING PERIOD. QU_FE_MSC_TOT QuantityTransactionCount decimal(7,0)
ContainerDepositTotalAmount The total monetary amount of container discounts collected by OPERATOR for each REPORTING PERIOD. CP_DS_CNR_TOT Money decimal(16,5)
TotalContainerDepositCount The total number of container deposits collected by OPERATOR for each REPORTING PERIOD. QU_DS_CNR_TOT QuantityTransactionCount decimal(7,0)
PaymentsCollectedTotalAmount The total monetary amount of payments collected by OPERATOR for each REPORTING PERIOD. CP_PYM_CLT_TOT Money decimal(16,5)
TotalPaymentsCollectedCount The total number of payments on account received by OPERATOR for each REPORTING PERIOD. QU_PYM_CLT_TOT QuantityTransactionCount decimal(7,0)
LayawayPaymentsCollectedTotalAmount The total monetary amount of layaway payments collected by OPERATOR for each REPORTING PERIOD. CP_PYM_LY_CLT_TOT MoneyShortCost decimal(16,5)
TotalLayawayPaymentsCollectedCount The total number of layaways payments collected by OPERATOR for each REPORTING PERIOD. QU_PYM_LY_CLT_TOT QuantityTransactionCount decimal(7,0)
PettyCashDisbursementTotalAmount The total monetary amount of petty cash disbursements by OPERATOR for each REPORTING PERIOD. CP_DSB_PTY_CSH_TOT Money decimal(16,5)
TotalPettyCashDisbursementLineItemCount The total number of disbursement line items made by OPERATOR for each REPORTING PERIOD. QU_DSB_PTY_LN_ITM QuantityTransactionCount decimal(7,0)
GrossSalesExTaxTotalAmount The total monetary amount of gross sales excluding tax recorded by OPERATOR for each REPORTING PERIOD. CP_SLS_GS_EX_TX Money decimal(16,5)
TaxTotalAmount The total tax amount recorded by OPERATOR for each REPORTING PERIOD. CP_TX_TOT Money decimal(16,5)
TaxExemptTotalAmount The total tax exempt amount recorded by OPERATOR for each REPORTING PERIOD. CP_TX_EXM_TOT Money decimal(16,5)
TotalTaxExemptTransactionCount The total number of tax exempt transactions recorded by OPERATOR for each REPORTING PERIOD. QU_TRN_TX_EXM_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemOverrideCount The total number of line item overrides made by OPERATOR for each REPORTING PERIOD. QU_LTM_OVRD_TOT QuantityTransactionCount decimal(7,0)
TotalWeighedLineItemCount The total number of weighed line items recorded by OPERATOR for each REPORTING PERIOD. QU_ITM_LN_WT_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemKeyedCount The total number of ITEMs keyed at the point of sale by OPERATOR for each REPORTING PERIOD. QU_LTM_KY_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemScannedCount The total number of ITEMs scanned by OPERATOR for each REPORTING PERIOD. QU_LTM_SC_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemKeyedPercentage The percentage of ITEMs keyed at the point of sale compared to the total sold ITEMs by the OPERATOR for each REPORTING PERIOD. PE_LTM_KY_TOT Percent decimal(7,4)
TotalLineItemScannedPercentage The percentage of ITEMs scanned compared to the total sold ITEMs by the OPERATOR for each REPORTING PERIOD. PE_LTM_SC_TOT Percent decimal(7,4)
TotalLineItemOpenDepartmentCount The number of ITEMs recorded through an open department by OPERATOR for each REPORTING PERIOD. QU_LTM_DPT_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemOpenDepartmentPercentage The percentage of ITEMs recorded through an open department compared to the total ITEMs by OPERATOR for each REPORTING PERIOD. PE_LTM_DPT_TOT Percent decimal(7,4)
NoSaleTransactionCount The total number of no sale transactions recorded by OPERATOR for each REPORTING PERIOD. QU_TRN_NO_SLS QuantityTransactionCount decimal(7,0)
TotalRingTime The total time expressed in minutes spent scanning or keying ITEMs by OPERATOR for each REPORTING PERIOD. IN_RNG_TOT QuantityShortCountSeconds decimal(5,0)
TotalIdleTime The total time expressed in minutes by operator where no sales are being recorded for each REPORTING PERIOD. IN_IDL_TOT QuantityShortCountSeconds decimal(5,0)
LockTime The time expressed in minutes when the WORKSTATION is locked even though the OPERATOR has signed on for each REPORTING PERIOD. IN_LCK_OPR QuantityShortCountSeconds decimal(5,0)
TotalSaleLineItemCount The total number of line item sales recorded by OPERATOR for each REPORTING PERIOD. QU_LTM_SLS_TOT QuantityTransactionCount decimal(7,0)
TotalSignOnCount The total number of sign-offs made by OPERATOR for each REPORTING PERIOD. QU_SGN_ON_TOT QuantityTransactionCount decimal(7,0)
TotalSignOffCount The total number of sign-on made by OPERATOR for each REPORTING PERIOD. QU_SGN_OFF_TOT QuantityTransactionCount decimal(7,0)
TotalTenderOverAmount The total monetary amount of tender overages recorded against the workstation OPERATOR for each REPORTING PERIOD. CP_TND_OVR_TOT Money decimal(16,5)
TotalTenderUnderAmount The total monetary amount of tender shortages recorded by OPERATOR for each REPORTING PERIOD. CP_MD_TND_PKP_TOT Money decimal(16,5)
IntermediateTenderReconciliationCount The total number of intermediate tender reconciliations for an OPERATOR for each REPORTING PERIOD. QU_RCN_INTN_TND QuantityTransactionCount decimal(7,0)
TotalSendCheckAmount The total monetary amount of send checks recorded by OPERATOR for each REPORTING PERIOD. CP_CHK_SND_TOT Money decimal(16,5)
TotalSendCheckCount The total number of send checks recorded by OPERATOR for each REPORTING PERIOD. QU_CHK_SND_TOT QuantityTransactionCount decimal(7,0)
SuspendedTotalAmount The total number of TRANSACTIONs suspended by OPERATOR for each REPORTING PERIOD. CP_SLS_SPN_TOT Money decimal(16,5)
SuspendedTransactionCount The total monetary amount of TRANSACTIONs suspended by OPERATOR for each REPORTING PERIOD. QU_TRN_SPN_TOT QuantityTransactionCount decimal(7,0)
ResumedTotalAmount The total monetary amount of TRANSACTIONs resumed by OPERATOR for each REPORTING PERIOD. CP_SLS_RSM_TOT Money decimal(16,5)
WorkstationResumedTransactionCount The total number of resumed transactions recorded by OPERATOR for each REPORTING PERIOD. QU_SLS_RSM_TRN_TOT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
Operator is tracked by OperatorHistory
ReportingPeriod delineates OperatorHistory
OperatorHistory may include OperatorTenderHistory
OperatorHistory may include OperatorTaxHistory

Logical Views containing OperatorHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03120 - Reporting - Store Operations - Period View
Logical 03150 - Reporting - Store Operations - Operator View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 11160 - Worker - Reporting View